SQL, moving million records from a database to other database [migrated]

Posted by Ryoma on Programmers See other posts from Programmers or by Ryoma
Published on 2013-10-24T23:45:00Z Indexed on 2013/10/25 4:14 UTC
Read the original article Hit count: 426

Filed under:
|

I am a C# developer, I am not really good with SQL. I have a simple questions here. I need to move more than 50 millions records from a database to other database. I tried to use the import function in ms SQL, however it got stuck because the log was full (I got an error message The transaction log for database 'mydatabase' is full due to 'LOG_BACKUP'). The database recovery model was set to simple. My friend said that importing millions records using task->import data will cause the log to be massive and told me to use loop instead to transfer the data, does anyone know how and why? thanks in advance

© Programmers or respective owner

Related posts about sql

Related posts about sql-server